package com.bt.lms.dao.servise;

import com.bt.lms.bo.TeachingPlanCondition;
import com.bt.lms.entity.TeachingPlanBasicInfo;
import com.bt.lms.bo.Page;

import java.sql.SQLException;

/**
 * 教学计划Dao
 * @author 李舒淇
 */
public interface TeachingPlanDao {

    /**
     * 新增教学计划
     * @param sql  sql语句
     * @param teachingPlanBasicInfo  教学计划基本信息
     * @return 是否成功
     */
    public int insert (String sql, TeachingPlanBasicInfo teachingPlanBasicInfo) throws Exception;


    /**
     * 查看教学计划详情
     * @param sql sql语句
     * @return 是否成功
     */
    public TeachingPlanBasicInfo select(String sql,TeachingPlanBasicInfo teachingPlanBasicInfo,Long id) throws Exception;


    /**
     * 编辑教学计划
     * @param sql sql语句
     * @param teachingPlanBasicInfo  教学计划基本信息
     * @param id  教学计划id
     * @return 是否成功
     * @throws Exception
     */
    public boolean edit(String sql,TeachingPlanBasicInfo teachingPlanBasicInfo,Long id) throws Exception;

    /**
     * 启用教学计划
     * @param sql
     * @return 是否成功
     */
    public boolean enable(String sql,Long id) throws Exception;


    /**
     * 删除
     * @param sql
     * @return 是否成功
     */
    public boolean delete(String sql, Long id) throws Exception;

    /**
     * 确认完成
     * @param sql
     * @return 是否成功
     */
    public boolean accomplish(String sql, Long id) throws Exception;

    /**
     * 分页查询
     * @param page
     * @return
     */
    public Page<TeachingPlanBasicInfo> query(String sql, Page<TeachingPlanCondition> page, Page<TeachingPlanBasicInfo> teachingPage) throws SQLException;





}
